MySQL Binlog 权限

您所在的位置：网站首页 › MySQL 订阅 › MySQL Binlog 权限

MySQL Binlog 权限

2024-07-17 19:52| 来源: 网络整理| 查看: 265

Check binlog status -- https://github.com/alibaba/canal/wiki/AdminGuide show variables like 'log_bin'; show variables like 'binlog_format'; MySQL Binlog权限需要三个权限 SELECT, REPLICATION SLAVE, REPLICATION CLIENT GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%' IDENTIFIED BY 'canal'; 缺乏SELECT权限时，报错为 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'canal'@'%' to database 'binlog' 缺乏REPLICATION SLAVE权限时，报错为 java.io.IOException: Error When doing Register slave:ErrorPacket [errorNumber=1045, fieldCount=-1, message=Access denied for user 'canal'@'%' 缺乏REPLICATION CLIENT权限时，报错为 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT privilege(s) for this operation

Binlog为什么需要这些权限：

Select权限代表允许从表中查看数据

Replication client权限代表允许执行show master status,show slave status,show binary logs命令 Replication slave权限代表允许slave主机通过此用户连接master以便建立主从复制关系

ref: https://github.com/DTStack/flinkx/blob/master/docs/connectors/binlog/binlog-source.md

【本文地址】

MySQL Binlog 权限

MySQL Binlog 权限

今日新闻

推荐新闻